>I’ve run into a number of problems recently with dealing with old databases of ours which are encoded with LATIN1. Now, with postgres 8.3 (maybe before) you’ll get a message if you try to create LATIN1 saying something like createdb: database creation failed: ERROR: encoding LATIN1 does not match server’s locale en_US.UTF-8DETAIL: The server’s LC_CTYPE setting requires encoding UTF8. I got bored trying to work out why – it seems to be that postgres now prevents what it shouldn’t have … Continue reading >Postgres – Converting Encodings